Model Table SUB PROJECT

This model dimension represents sub projects and is based on the IFS Cloud dimension DIM_SUB_PROJECT. All models that refer to this dimension will have the attributes and hierarchies as described below.

Natural parent is project, i.e. each project has its own set of sub projects. A sub project can however have another sub project as a sub project parent.

Attributes

AttributeDescription (where applicable)
DepartmentThe department (DEPARTMENT) referenced by the sub project
L1Level 1 in Sub Project hierarchy structure
L10Level 10 in Sub Project hierarchy structure
L2Level 2 in Sub Project hierarchy structure
L3Level 3 in Sub Project hierarchy structure
L4Level 4 in Sub Project hierarchy structure
L5Level 5 in Sub Project hierarchy structure
L6Level 6 in Sub Project hierarchy structure
L7Level 7 in Sub Project hierarchy structure
L8Level 8 in Sub Project hierarchy structure
L9Level 9 in Sub Project hierarchy structure
ProjectThe project identity that the sub project belongs to. (PROJECT_ID)
Sub ProjectDefined as PROJECT_ID + ' - ' +SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project DescriptionThe description of the sub project (SUB_PROJECT_DESCRIPTION)
Sub Project IdThe identity of the sub project (SUB_PROJECT_ID)
Sub Project Id DescriptionDefined as SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project ManagerName of the sub project manager (MANAGER_NAME)

Hierarchies

HierarchyLevel
SubProjectHy
Project
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10

USED BY MODEL(S)

Model Name
Procurement

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
SUB PROJECTDIM_SUB_PROJECT_TMDIM_SUB_PROJECT_BIDIM_SUB_PROJECTOn Line